UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'h/47pmoW5OZQ6BeAjRfw3u49smiQMa+Nk2bfCAUq+Ng='
WHERE
key_id = 'cc1e4527d059a36d355466338b7b28943aebb84aad81a261e2cee837b87b362e'
AND (
token = 'h/47pmoW5OZQ6BeAjRfw3u49smiQMa+Nk2bfCAUq+Ng='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)