UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iOqsVlpeb0boHCg4CxF0IZjUQuBME8c8nF6I39Bzdl4='
WHERE
key_id = 'e0e78465234d848e0de8f879ddccdcdf39e6c7e14bca176beabd0e0a624b10bb'
AND (
token = 'iOqsVlpeb0boHCg4CxF0IZjUQuBME8c8nF6I39Bzdl4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)