UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1rcDZagOpg8bgAvfmTUpRetNFIOgk792Ns94pfiLIJ4='
WHERE
key_id = '2efad50a1e35243a5d32c920eebb1ce23eb3d92ee5b1e1b6463b290ce37fed51'
AND (
token = '1rcDZagOpg8bgAvfmTUpRetNFIOgk792Ns94pfiLIJ4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)