UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TA7PTvwHIO5OFuAUS0IsVqmYF7FER8E+fEEY9eUG80w='
WHERE
key_id = '981b1c317fcd48c2c6fe0a9ae625d43ebb75a8d78c0da488ee1ee23c50ffee1a'
AND (
token = 'TA7PTvwHIO5OFuAUS0IsVqmYF7FER8E+fEEY9eUG80w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)