UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KD71omd0P2TUfBW4e7kbG0d1BekG6pZDC3hl7DPDYPQ='
WHERE
key_id = '27be2b48c6a3371c8efff0e6bc56633aa962ddf9f224fb8fa83830142768ff05'
AND (
token = 'KD71omd0P2TUfBW4e7kbG0d1BekG6pZDC3hl7DPDYPQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)