UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NLnCXVF867qkzqqxkgQrN4UyKq9fEi1KJnZesbb1jwc='
WHERE
key_id = '3cbd3b901f6663edaa70007acb3f0ade5a4b92caf716876884b71c4c710e0d22'
AND (
token = 'NLnCXVF867qkzqqxkgQrN4UyKq9fEi1KJnZesbb1jwc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)