UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'A29tWVg+9ziZKJVLTTP0xFNkdHjlnNcSw8LJnG7DmI8='
WHERE
key_id = 'fd97b43fd24d330299d1b632ef62bcf5ec0d8c145bb59cb705781891ab6b8ebf'
AND (
token = 'A29tWVg+9ziZKJVLTTP0xFNkdHjlnNcSw8LJnG7DmI8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)