UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VeW7ob7NFV5euaaKbLspTn2ydhq5YUoJdDyz19Plhxw='
WHERE
key_id = '1b5c612123890db7b028bbbbee47867fa5fc203a787c916212fbc00de2d1e943'
AND (
token = 'VeW7ob7NFV5euaaKbLspTn2ydhq5YUoJdDyz19Plhxw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)