UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xDm0q5OUFtg2es0jfDU/lC6odiYm2YyZk6sBXG7Cubg='
WHERE
key_id = 'd9792d1b44de1e7440eba74ad3a8171f15d37ef3c881d6882b32cff2bfbb7f64'
AND (
token = 'xDm0q5OUFtg2es0jfDU/lC6odiYm2YyZk6sBXG7Cubg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)