UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'chNzXiM6zDC/HIUh2bPam7wrT+usFPZUU3yJSFpWizU='
WHERE
key_id = '3f1bf83c0a27072a018383ab9a9859af993670ef5daada54c013b64dfc78b603'
AND (
token = 'chNzXiM6zDC/HIUh2bPam7wrT+usFPZUU3yJSFpWizU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)