UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CHQcJaxHscab2cuGkE6VlE09Z9LO8h1QEihYF4Iw/I4='
WHERE
key_id = '40a6c1396f7e595f18a62fad234387170925c5d384ba16c3ddcc65260683abb8'
AND (
token = 'CHQcJaxHscab2cuGkE6VlE09Z9LO8h1QEihYF4Iw/I4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)