UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8HQSSSPFA2OmWpEdpOc2d57ZwWHt7+m85GovlCroOGU='
WHERE
key_id = 'de1cd83308cab978a1a9fc747a4e29e38b4fb105d54c213e7e6c19642e697a8a'
AND (
token = '8HQSSSPFA2OmWpEdpOc2d57ZwWHt7+m85GovlCroOGU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)