UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1KPvPz7Gjy/QFrpiDqjAYHw1meT55QvdYqJj0Bo+3zE='
WHERE
key_id = '5f66ae256784229260514aceaaaeefa1ee5ebb87f0b2a0dd4f0de6940ef52a96'
AND (
token = '1KPvPz7Gjy/QFrpiDqjAYHw1meT55QvdYqJj0Bo+3zE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)