UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+j8j1zKJ6nZ7jf9F+ky1lPs8R/qfCUbNENnH+Jnbmr4='
WHERE
key_id = '22c65adf48dccefa50e95748682246556cf2d95129b5bf7cb7cd5bd07fa8b95a'
AND (
token = '+j8j1zKJ6nZ7jf9F+ky1lPs8R/qfCUbNENnH+Jnbmr4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)