UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zAHSP6mtG9hXhB7/yQOsoN5yuL1OktQqzRSjc7XjMww='
WHERE
key_id = '1c50b8cfea9dadcb929654f4f660c3e9b0e8d7f210975a3cebc779a68fe47292'
AND (
token = 'zAHSP6mtG9hXhB7/yQOsoN5yuL1OktQqzRSjc7XjMww='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)