UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QE8NJ9O1jVPdHnDlctJMLHOt3J4wqr+hA6dwr0m8KxU='
WHERE
key_id = 'c8a09d76bb81da7a849a670a65304d31c1578265704fb485a1b5a2179ddbdf11'
AND (
token = 'QE8NJ9O1jVPdHnDlctJMLHOt3J4wqr+hA6dwr0m8KxU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)