UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VNk7l4IhmlFdg82p+U6MICibmb+xhalY9g+6tMYRK+g='
WHERE
key_id = '2c3a422c74768026931a2299720c657d664d9cbadccc6c691966d5dad2809e2e'
AND (
token = 'VNk7l4IhmlFdg82p+U6MICibmb+xhalY9g+6tMYRK+g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)