UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KmctVX3eIs+EI7eMXJdn94QebqL0rDCJRE1+B2jAKjw='
WHERE
key_id = 'b302c6b1e3eaea1c6601bc683c06ca0a9b6950f6ff96fb9c715be0bf3f199c12'
AND (
token = 'KmctVX3eIs+EI7eMXJdn94QebqL0rDCJRE1+B2jAKjw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)