UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7bPluDMdOyKwVEIrTZUqyoK+yTlGUM+Jtg6ZEcvV/78='
WHERE
key_id = '42ff238cefc80dffc96b59ca6e69c5d7935019ad15af42be6a1784eb673807ab'
AND (
token = '7bPluDMdOyKwVEIrTZUqyoK+yTlGUM+Jtg6ZEcvV/78='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)