UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nEXC6liST+YKa7jvyFai7y3v0r5IRS762sZrB9DR3/g='
WHERE
key_id = 'bfa8dfe4f1117d5d0716b7bfe7cd18ef7af47ab57f65a8752d730aeccc36dd4e'
AND (
token = 'nEXC6liST+YKa7jvyFai7y3v0r5IRS762sZrB9DR3/g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)