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