UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BrenPs+gaop+KXNsWuBVq4M0BOvj8N+131hBz+muxZw='
WHERE
key_id = '2be6b409e19c339f82c24b9acd9558f53895ccc3c893f9cbba2a4e16ec7e9fdc'
AND (
token = 'BrenPs+gaop+KXNsWuBVq4M0BOvj8N+131hBz+muxZw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)