UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bIcv+/vJYjM55vbK1CeVhcQMr/YXmaJ3o71AzsER7Do='
WHERE
key_id = '3def69c6cce3e8d4a596238b9898771b5a3418d756f19aa0a67361398f360738'
AND (
token = 'bIcv+/vJYjM55vbK1CeVhcQMr/YXmaJ3o71AzsER7Do='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)