UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MYZ9zTardgIOozinx6aGExlQc02AT5UiW4y8PTci99Q='
WHERE
key_id = '7a65ba8253cbe9b6f250512bb01bc8fa69e8f6c7d15cf8878bac06d82d578860'
AND (
token = 'MYZ9zTardgIOozinx6aGExlQc02AT5UiW4y8PTci99Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)