UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'b4VGqJMfZbgIqNZ1XKxxKu6/qz2i3+wZS5nKFQ16Lpk='
WHERE
key_id = 'c992a0f983cea7c5e191337cd90cfc61b61bc7fe81fa8c5120f29aa1396902f0'
AND (
token = 'b4VGqJMfZbgIqNZ1XKxxKu6/qz2i3+wZS5nKFQ16Lpk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)