UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hHfdErzPQgnDPq29t9DBr9kek9px7PS2t3rG3xhaidE='
WHERE
key_id = 'ce0ddc8643d3a5ede5857b419b5a1b9d592eea9c31f6b3f15ddb1d4f42d0f76d'
AND (
token = 'hHfdErzPQgnDPq29t9DBr9kek9px7PS2t3rG3xhaidE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)