UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dMyw1jJfyps/YI6rtmWzyefMbgypxLzCdmreI3glzYo='
WHERE
key_id = 'b7f7bdb72f2c78b6234f4d6bec8009ea145b71986dde98950f6db92999877748'
AND (
token = 'dMyw1jJfyps/YI6rtmWzyefMbgypxLzCdmreI3glzYo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)