UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bCHx77BvKkA8A8M8za3DjC9/FrQsxa91rQNeNGV5pqQ='
WHERE
key_id = 'a1e8390d98f9da01d8eec80c53934f06aeb43e230dfec21774bd06e687bcc8f4'
AND (
token = 'bCHx77BvKkA8A8M8za3DjC9/FrQsxa91rQNeNGV5pqQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)