UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zNHiJQD13GIAnV80dMb7orWAm3TtcIiOrweuaoKuvkI='
WHERE
key_id = '91d34d7e5a19b0617c5fae960070e392e7cfa70052d799561d1860a1201bcb9b'
AND (
token = 'zNHiJQD13GIAnV80dMb7orWAm3TtcIiOrweuaoKuvkI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)