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