UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U8uUPtAXJEAv7icZJbG8Iov/Lj5T9kP5La3ajEbx7Fk='
WHERE
key_id = '779d1873d991d91c7ef1cbd8b3b85d2bfa552579cee8ee9b0b25a259ebd2f1dc'
AND (
token = 'U8uUPtAXJEAv7icZJbG8Iov/Lj5T9kP5La3ajEbx7Fk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)