UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nL3+x7aYYiJMrWJTwtrH9EJZLw/diot9+O3zopE6wzA='
WHERE
key_id = '7974d47ee9734e1d5e80423a1d465f1ea089d1fecb0924338bbbc63594d14b48'
AND (
token = 'nL3+x7aYYiJMrWJTwtrH9EJZLw/diot9+O3zopE6wzA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)