UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4JaY9b3wJsykSOwE7k0NpG1NWyUrCXueYUKkTC9XCYo='
WHERE
key_id = '704ea3d85345d0553b042a272fbf971b925ad63007d3dd546254dc53fe3dca98'
AND (
token = '4JaY9b3wJsykSOwE7k0NpG1NWyUrCXueYUKkTC9XCYo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)